If you are using SAS^® Customer Intelligence Studio and uploading Contact History tables to a location on the Netezza database, you might encounter the following error:

[ERROR] 
SAS Demo User crm.custdata.storedprocess.StoredProcess - An unexpected exception 
has been thrown when executing stored process: MACHUpdate 

com.sas.analytics.crm.error.client.CodingException: 

Contact History schema not specified, cannot update contact history.

To work around the error, modify the ciddlntz.sas script file and add double quotes (") to every CREATE TABLE NAME statement. You also need to add the PRESERVE_TAB_NAMES = YES option to the Common Data Model LIBNAME statement in the SAS^® Management Console.

If you are exporting to a Netezza table, make sure that the preceding changes are relevant for the export LIBNAME in the appserver_autoexec.sas file.

The default for Netezza is lowercase, therefore, running the DDL script without using the double quotes will always create them lowercase.

This occurs because Netezza, like most databases, ignores case when you create them with default lowercase names, but unlike most databases, once you create them uppercase you must always use uppercase names.

Operating System and Release Information